Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	18333
Missing cells	30006
Missing cells (%)	10.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	98.0 B

Variable types

Numeric	8
Categorical	6
Boolean	1

Warnings

`car_type` has a high cardinality: 373 distinct values	High cardinality
`first_date` has a high cardinality: 214 distinct values	High cardinality
`average_price` is highly correlated with `price` and 1 other fields	High correlation
`price` is highly correlated with `average_price` and 1 other fields	High correlation
`diff_price` is highly correlated with `average_price` and 2 other fields	High correlation
`diff_price_perc` is highly correlated with `diff_price`	High correlation
`average_price` is highly correlated with `price` and 1 other fields	High correlation
`price` is highly correlated with `average_price` and 1 other fields	High correlation
`diff_price` is highly correlated with `average_price` and 2 other fields	High correlation
`diff_price_perc` is highly correlated with `diff_price`	High correlation
`average_price` is highly correlated with `price`	High correlation
`price` is highly correlated with `average_price` and 1 other fields	High correlation
`diff_price` is highly correlated with `price` and 1 other fields	High correlation
`diff_price_perc` is highly correlated with `diff_price`	High correlation
`DI` has 11673 (63.7%) missing values	Missing
`sold` has 11673 (63.7%) missing values	Missing
`first_date` has 6660 (36.3%) missing values	Missing
`car_id` is uniformly distributed	Uniform
`car_id` has unique values	Unique
`antiquity` has 405 (2.2%) zeros	Zeros

Reproduction

Analysis started	2021-05-31 04:32:32.221595
Analysis finished	2021-05-31 04:32:42.037277
Duration	9.82 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

car_id
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	18333
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9997.398189

Minimum	0
Maximum	19999
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	143.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1015.6
Q1	5013
median	9991
Q3	14995
95-th percentile	18988.4
Maximum	19999
Range	19999
Interquartile range (IQR)	9982

Descriptive statistics

Standard deviation	5766.700943
Coefficient of variation (CV)	0.576820172
Kurtosis	-1.199077161
Mean	9997.398189
Median Absolute Deviation (MAD)	4992
Skewness	-0.000379208247
Sum	183282301
Variance	33254839.77
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
9534	1	< 0.1%
1354	1	< 0.1%
7497	1	< 0.1%
5448	1	< 0.1%
19779	1	< 0.1%
17730	1	< 0.1%
11583	1	< 0.1%
15677	1	< 0.1%
13644	1	< 0.1%
Other values (18323)	18323	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
19999	1	< 0.1%
19998	1	< 0.1%
19997	1	< 0.1%
19996	1	< 0.1%
19995	1	< 0.1%
19994	1	< 0.1%
19993	1	< 0.1%
19991	1	< 0.1%
19990	1	< 0.1%
19989	1	< 0.1%

car_type
Categorical

HIGH CARDINALITY

Distinct	373
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	143.4 KiB

Serie 1	170
Ram 1500 V6	158
Odyssey	140
CR-V	138
March	135
Other values (368)	17592

Length

Max length	25
Median length	6
Mean length	6.88610702
Min length	2

Characters and Unicode

Total characters	126243
Distinct characters	65
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Supra
2nd row	Supra
3rd row	Supra
4th row	Supra
5th row	Supra

Common Values

Value	Count	Frequency (%)
Serie 1	170	0.9%
Ram 1500 V6	158	0.9%
Odyssey	140	0.8%
CR-V	138	0.8%
March	135	0.7%
Serie 7	135	0.7%
Transit	134	0.7%
Terrain	132	0.7%
Cherokee	132	0.7%
Saveiro	132	0.7%
Other values (363)	16927	92.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
clase	924	3.7%
serie	693	2.8%
ram	344	1.4%
cargo	338	1.3%
van	336	1.3%
quattro	300	1.2%
range	285	1.1%
rover	285	1.1%
v6	283	1.1%
1500	263	1.0%
Other values (380)	21113	83.9%

Most occurring characters

Value	Count	Frequency (%)
a	11755	9.3%
e	10239	8.1%
r	9947	7.9%
	6904	5.5%
o	6206	4.9%
i	5744	4.5%
n	5294	4.2%
t	4985	3.9%
C	4394	3.5%
s	4007	3.2%
Other values (55)	56768	45.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	80194	63.5%
Uppercase Letter	27798	22.0%
Decimal Number	10795	8.6%
Space Separator	6904	5.5%
Dash Punctuation	552	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	11755	14.7%
e	10239	12.8%
r	9947	12.4%
o	6206	7.7%
i	5744	7.2%
n	5294	6.6%
t	4985	6.2%
s	4007	5.0%
l	3014	3.8%
u	2446	3.1%
Other values (17)	16557	20.6%

Uppercase Letter

Value	Count	Frequency (%)
C	4394	15.8%
S	3834	13.8%
R	2122	7.6%
M	1768	6.4%
T	1678	6.0%
V	1493	5.4%
A	1442	5.2%
X	1405	5.1%
L	1403	5.0%
E	1257	4.5%
Other values (16)	7002	25.2%

Decimal Number

Value	Count	Frequency (%)
0	3595	33.3%
5	1478	13.7%
3	1034	9.6%
1	891	8.3%
6	819	7.6%
4	798	7.4%
8	780	7.2%
2	719	6.7%
7	572	5.3%
9	109	1.0%

Space Separator

Value	Count	Frequency (%)
	6904	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	552	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	107992	85.5%
Common	18251	14.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	11755	10.9%
e	10239	9.5%
r	9947	9.2%
o	6206	5.7%
i	5744	5.3%
n	5294	4.9%
t	4985	4.6%
C	4394	4.1%
s	4007	3.7%
S	3834	3.6%
Other values (43)	41587	38.5%

Common

Value	Count	Frequency (%)
	6904	37.8%
0	3595	19.7%
5	1478	8.1%
3	1034	5.7%
1	891	4.9%
6	819	4.5%
4	798	4.4%
8	780	4.3%
2	719	3.9%
7	572	3.1%
Other values (2)	661	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	126220	> 99.9%
Latin 1 Sup	23	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	11755	9.3%
e	10239	8.1%
r	9947	7.9%
	6904	5.5%
o	6206	4.9%
i	5744	4.6%
n	5294	4.2%
t	4985	3.9%
C	4394	3.5%
s	4007	3.2%
Other values (54)	56745	45.0%

Latin 1 Sup

Value	Count	Frequency (%)
ó	23	100.0%

color
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	143.4 KiB

Black	6415
White	4625
Red	3706
Blue	3035
Orange	552

Length

Max length	6
Median length	5
Mean length	4.460262914
Min length	3

Characters and Unicode

Total characters	81770
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Blue
2nd row	Black
3rd row	Black
4th row	Blue
5th row	Black

Common Values

Value	Count	Frequency (%)
Black	6415	35.0%
White	4625	25.2%
Red	3706	20.2%
Blue	3035	16.6%
Orange	552	3.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
black	6415	35.0%
white	4625	25.2%
red	3706	20.2%
blue	3035	16.6%
orange	552	3.0%

Most occurring characters

Value	Count	Frequency (%)
e	11918	14.6%
B	9450	11.6%
l	9450	11.6%
a	6967	8.5%
c	6415	7.8%
k	6415	7.8%
W	4625	5.7%
h	4625	5.7%
i	4625	5.7%
t	4625	5.7%
Other values (7)	12655	15.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	63437	77.6%
Uppercase Letter	18333	22.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	11918	18.8%
l	9450	14.9%
a	6967	11.0%
c	6415	10.1%
k	6415	10.1%
h	4625	7.3%
i	4625	7.3%
t	4625	7.3%
d	3706	5.8%
u	3035	4.8%
Other values (3)	1656	2.6%

Uppercase Letter

Value	Count	Frequency (%)
B	9450	51.5%
W	4625	25.2%
R	3706	20.2%
O	552	3.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	81770	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	11918	14.6%
B	9450	11.6%
l	9450	11.6%
a	6967	8.5%
c	6415	7.8%
k	6415	7.8%
W	4625	5.7%
h	4625	5.7%
i	4625	5.7%
t	4625	5.7%
Other values (7)	12655	15.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	81770	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	11918	14.6%
B	9450	11.6%
l	9450	11.6%
a	6967	8.5%
c	6415	7.8%
k	6415	7.8%
W	4625	5.7%
h	4625	5.7%
i	4625	5.7%
t	4625	5.7%
Other values (7)	12655	15.5%

km
Real number (ℝ_≥0)

Distinct	18328
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25285230.58

Minimum	1394070
Maximum	49452737
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	71.7 KiB

Quantile statistics

Minimum	1394070
5-th percentile	10621811.8
Q1	18990785
median	25306193
Q3	31534749
95-th percentile	40074969
Maximum	49452737
Range	48058667
Interquartile range (IQR)	12543964

Descriptive statistics

Standard deviation	8920231.687
Coefficient of variation (CV)	0.352784273
Kurtosis	-0.4563884981
Mean	25285230.58
Median Absolute Deviation (MAD)	6266302
Skewness	0.02280199573
Sum	4.635541321 × 10¹¹
Variance	7.957053335 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26147715	2	< 0.1%
30179528	2	< 0.1%
35675327	2	< 0.1%
28361231	2	< 0.1%
18804442	2	< 0.1%
28391599	1	< 0.1%
27176287	1	< 0.1%
29556917	1	< 0.1%
14114097	1	< 0.1%
20237619	1	< 0.1%
Other values (18318)	18318	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1394070	1	< 0.1%
1620426	1	< 0.1%
1646143	1	< 0.1%
1660807	1	< 0.1%
1708590	1	< 0.1%
1818247	1	< 0.1%
1859642	1	< 0.1%
1890364	1	< 0.1%
1891943	1	< 0.1%
2045134	1	< 0.1%

Value	Count	Frequency (%)
49452737	1	< 0.1%
49416201	1	< 0.1%
49404285	1	< 0.1%
49061130	1	< 0.1%
48822502	1	< 0.1%
48707264	1	< 0.1%
48695728	1	< 0.1%
48648519	1	< 0.1%
48617054	1	< 0.1%
48570426	1	< 0.1%

average_price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	700
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	551575.625

Minimum	101729
Maximum	997705
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	71.7 KiB

Quantile statistics

Minimum	101729
5-th percentile	149481
Q1	330625
median	559715
Q3	779453
95-th percentile	951729
Maximum	997705
Range	895976
Interquartile range (IQR)	448828

Descriptive statistics

Standard deviation	257173.25
Coefficient of variation (CV)	0.4662520289
Kurtosis	-1.208065629
Mean	551575.625
Median Absolute Deviation (MAD)	226560
Skewness	-0.02829320543
Sum	1.011203584 × 10¹⁰
Variance	6.613808333 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
307812	45	0.2%
238184	43	0.2%
133420	42	0.2%
820251	40	0.2%
671026	39	0.2%
469923	39	0.2%
598395	38	0.2%
196372	38	0.2%
652988	38	0.2%
121909	38	0.2%
Other values (690)	17933	97.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
101729	30	0.2%
102486	21	0.1%
106132	26	0.1%
106227	29	0.2%
107583	22	0.1%
108056	32	0.2%
112643	19	0.1%
117277	27	0.1%
120985	27	0.1%
121909	38	0.2%

Value	Count	Frequency (%)
997705	19	0.1%
997104	25	0.1%
997067	37	0.2%
993481	24	0.1%
992179	26	0.1%
992167	26	0.1%
990878	16	0.1%
988968	23	0.1%
986711	29	0.2%
986078	33	0.2%

transmission
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	143.4 KiB

Automatic	14540
Manual	3793

Length

Max length	9
Median length	9
Mean length	8.379315988
Min length	6

Characters and Unicode

Total characters	153618
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manual
2nd row	Manual
3rd row	Manual
4th row	Manual
5th row	Manual

Common Values

Value	Count	Frequency (%)
Automatic	14540	79.3%
Manual	3793	20.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
automatic	14540	79.3%
manual	3793	20.7%

Most occurring characters

Value	Count	Frequency (%)
t	29080	18.9%
a	22126	14.4%
u	18333	11.9%
A	14540	9.5%
o	14540	9.5%
m	14540	9.5%
i	14540	9.5%
c	14540	9.5%
M	3793	2.5%
n	3793	2.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	135285	88.1%
Uppercase Letter	18333	11.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	29080	21.5%
a	22126	16.4%
u	18333	13.6%
o	14540	10.7%
m	14540	10.7%
i	14540	10.7%
c	14540	10.7%
n	3793	2.8%
l	3793	2.8%

Uppercase Letter

Value	Count	Frequency (%)
A	14540	79.3%
M	3793	20.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	153618	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	29080	18.9%
a	22126	14.4%
u	18333	11.9%
A	14540	9.5%
o	14540	9.5%
m	14540	9.5%
i	14540	9.5%
c	14540	9.5%
M	3793	2.5%
n	3793	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	153618	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	29080	18.9%
a	22126	14.4%
u	18333	11.9%
A	14540	9.5%
o	14540	9.5%
m	14540	9.5%
i	14540	9.5%
c	14540	9.5%
M	3793	2.5%
n	3793	2.5%

body_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	143.4 KiB

Sedan	10797
SUV	4544
Coupe	2160
Truck	832

Length

Max length	5
Median length	5
Mean length	4.504281896
Min length	3

Characters and Unicode

Total characters	82577
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sedan
2nd row	Sedan
3rd row	Sedan
4th row	Sedan
5th row	Sedan

Common Values

Value	Count	Frequency (%)
Sedan	10797	58.9%
SUV	4544	24.8%
Coupe	2160	11.8%
Truck	832	4.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
sedan	10797	58.9%
suv	4544	24.8%
coupe	2160	11.8%
truck	832	4.5%

Most occurring characters

Value	Count	Frequency (%)
S	15341	18.6%
e	12957	15.7%
d	10797	13.1%
a	10797	13.1%
n	10797	13.1%
U	4544	5.5%
V	4544	5.5%
u	2992	3.6%
C	2160	2.6%
o	2160	2.6%
Other values (5)	5488	6.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	55156	66.8%
Uppercase Letter	27421	33.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	12957	23.5%
d	10797	19.6%
a	10797	19.6%
n	10797	19.6%
u	2992	5.4%
o	2160	3.9%
p	2160	3.9%
r	832	1.5%
c	832	1.5%
k	832	1.5%

Uppercase Letter

Value	Count	Frequency (%)
S	15341	55.9%
U	4544	16.6%
V	4544	16.6%
C	2160	7.9%
T	832	3.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	82577	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	15341	18.6%
e	12957	15.7%
d	10797	13.1%
a	10797	13.1%
n	10797	13.1%
U	4544	5.5%
V	4544	5.5%
u	2992	3.6%
C	2160	2.6%
o	2160	2.6%
Other values (5)	5488	6.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82577	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	15341	18.6%
e	12957	15.7%
d	10797	13.1%
a	10797	13.1%
n	10797	13.1%
U	4544	5.5%
V	4544	5.5%
u	2992	3.6%
C	2160	2.6%
o	2160	2.6%
Other values (5)	5488	6.6%

DI
Real number (ℝ_≥0)

MISSING

Distinct	101
Distinct (%)	1.5%
Missing	11673
Missing (%)	63.7%
Infinite	0
Infinite (%)	0.0%
Mean	22.99414414

Minimum	1
Maximum	131
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	143.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	9
median	20
Q3	34
95-th percentile	56
Maximum	131
Range	130
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	17.3555903
Coefficient of variation (CV)	0.7547830523
Kurtosis	1.064841899
Mean	22.99414414
Median Absolute Deviation (MAD)	12
Skewness	0.9817592878
Sum	153141
Variance	301.2165147
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	235	1.3%
3	222	1.2%
2	220	1.2%
4	203	1.1%
5	202	1.1%
6	194	1.1%
8	189	1.0%
10	176	1.0%
7	170	0.9%
11	166	0.9%
Other values (91)	4683	25.5%
(Missing)	11673	63.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	235	1.3%
2	220	1.2%
3	222	1.2%
4	203	1.1%
5	202	1.1%
6	194	1.1%
7	170	0.9%
8	189	1.0%
9	166	0.9%
10	176	1.0%

Value	Count	Frequency (%)
131	1	< 0.1%
115	1	< 0.1%
113	1	< 0.1%
111	1	< 0.1%
107	1	< 0.1%
105	1	< 0.1%
101	1	< 0.1%
99	1	< 0.1%
96	1	< 0.1%
95	2	< 0.1%

price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	18152
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	603549.0625

Minimum	98972
Maximum	1175730
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	71.7 KiB

Quantile statistics

Minimum	98972
5-th percentile	164036.8
Q1	357402
median	608859
Q3	851566
95-th percentile	1041221.4
Maximum	1175730
Range	1076758
Interquartile range (IQR)	494164

Descriptive statistics

Standard deviation	283352.125
Coefficient of variation (CV)	0.4694765508
Kurtosis	-1.174217105
Mean	603549.0625
Median Absolute Deviation (MAD)	246789
Skewness	-0.002718279604
Sum	1.106486477 × 10¹⁰
Variance	8.028842394 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200131	3	< 0.1%
865562	2	< 0.1%
253301	2	< 0.1%
832461	2	< 0.1%
992410	2	< 0.1%
400242	2	< 0.1%
552063	2	< 0.1%
245609	2	< 0.1%
646595	2	< 0.1%
580963	2	< 0.1%
Other values (18142)	18312	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
98972	1	< 0.1%
99399	1	< 0.1%
103410	1	< 0.1%
103478	1	< 0.1%
103865	1	< 0.1%
103922	1	< 0.1%
104134	1	< 0.1%
104432	1	< 0.1%
104567	1	< 0.1%
104672	1	< 0.1%

Value	Count	Frequency (%)
1175730	1	< 0.1%
1172070	1	< 0.1%
1172007	1	< 0.1%
1171435	1	< 0.1%
1168799	1	< 0.1%
1168516	1	< 0.1%
1166356	1	< 0.1%
1166190	1	< 0.1%
1165003	1	< 0.1%
1164050	1	< 0.1%

sold
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	11673
Missing (%)	63.7%
Memory size	35.9 KiB

True	5507
False	1153
(Missing)	11673

Common Values
Chart

Value	Count	Frequency (%)
True	5507	30.0%
False	1153	6.3%
(Missing)	11673	63.7%

first_date
Categorical

HIGH CARDINALITY
MISSING

Distinct	214
Distinct (%)	1.8%
Missing	6660
Missing (%)	36.3%
Memory size	143.4 KiB

2019-08-27	75
2019-06-10	72
2019-07-24	72
2019-06-21	71
2019-08-12	71
Other values (209)	11312

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	116730
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2019-08-14
2nd row	2019-12-28
3rd row	2019-11-05
4th row	2019-08-26
5th row	2019-08-07

Common Values

Value	Count	Frequency (%)
2019-08-27	75	0.4%
2019-06-10	72	0.4%
2019-07-24	72	0.4%
2019-06-21	71	0.4%
2019-08-12	71	0.4%
2019-12-04	70	0.4%
2019-06-30	69	0.4%
2019-08-20	69	0.4%
2019-12-25	68	0.4%
2019-06-15	67	0.4%
Other values (204)	10969	59.8%
(Missing)	6660	36.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2019-08-27	75	0.6%
2019-07-24	72	0.6%
2019-06-10	72	0.6%
2019-08-12	71	0.6%
2019-06-21	71	0.6%
2019-12-04	70	0.6%
2019-08-20	69	0.6%
2019-06-30	69	0.6%
2019-12-25	68	0.6%
2019-06-15	67	0.6%
Other values (204)	10969	94.0%

Most occurring characters

Value	Count	Frequency (%)
0	24711	21.2%
-	23346	20.0%
1	23340	20.0%
2	18332	15.7%
9	14405	12.3%
8	2931	2.5%
6	2832	2.4%
7	2797	2.4%
3	1752	1.5%
5	1155	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93384	80.0%
Dash Punctuation	23346	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	24711	26.5%
1	23340	25.0%
2	18332	19.6%
9	14405	15.4%
8	2931	3.1%
6	2832	3.0%
7	2797	3.0%
3	1752	1.9%
5	1155	1.2%
4	1129	1.2%

Dash Punctuation

Value	Count	Frequency (%)
-	23346	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	116730	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	24711	21.2%
-	23346	20.0%
1	23340	20.0%
2	18332	15.7%
9	14405	12.3%
8	2931	2.5%
6	2832	2.4%
7	2797	2.4%
3	1752	1.5%
5	1155	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	116730	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	24711	21.2%
-	23346	20.0%
1	23340	20.0%
2	18332	15.7%
9	14405	12.3%
8	2931	2.5%
6	2832	2.4%
7	2797	2.4%
3	1752	1.5%
5	1155	1.0%

diff_price
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	16919
Distinct (%)	92.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-51973.45732

Minimum	-178663
Maximum	10314
Zeros	0
Zeros (%)	0.0%
Negative	18294
Negative (%)	99.8%
Memory size	143.4 KiB

Quantile statistics

Minimum	-178663
5-th percentile	-129140.8
Q1	-76580
median	-42721
Q3	-20134
95-th percentile	-6497.8
Maximum	10314
Range	188977
Interquartile range (IQR)	56446

Descriptive statistics

Standard deviation	38664.47826
Coefficient of variation (CV)	-0.7439273864
Kurtosis	-0.09974256639
Mean	-51973.45732
Median Absolute Deviation (MAD)	25644
Skewness	-0.842080187
Sum	-952829393
Variance	1494941879
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-34981	4	< 0.1%
-13329	4	< 0.1%
-37977	4	< 0.1%
-47413	4	< 0.1%
-21248	4	< 0.1%
-17550	4	< 0.1%
-20586	4	< 0.1%
-13325	4	< 0.1%
-6713	3	< 0.1%
-47391	3	< 0.1%
Other values (16909)	18295	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-178663	1	< 0.1%
-178526	1	< 0.1%
-176632	1	< 0.1%
-175568	1	< 0.1%
-175460	1	< 0.1%
-175363	1	< 0.1%
-175082	1	< 0.1%
-175035	1	< 0.1%
-175003	1	< 0.1%
-174177	1	< 0.1%

Value	Count	Frequency (%)
10314	1	< 0.1%
8611	1	< 0.1%
6503	1	< 0.1%
5698	1	< 0.1%
4585	1	< 0.1%
3788	1	< 0.1%
2807	1	< 0.1%
2780	1	< 0.1%
2743	1	< 0.1%
2580	1	< 0.1%

diff_price_perc
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	18329
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.09366516909

Minimum	-0.179993965
Maximum	0.08004052685
Zeros	0
Zeros (%)	0.0%
Negative	18294
Negative (%)	99.8%
Memory size	143.4 KiB

Quantile statistics

Minimum	-0.179993965
5-th percentile	-0.1694551493
Q1	-0.1355795484
median	-0.09432077725
Q3	-0.05135914869
95-th percentile	-0.01727285364
Maximum	0.08004052685
Range	0.2600344918
Interquartile range (IQR)	0.08422039967

Descriptive statistics

Standard deviation	0.04900667101
Coefficient of variation (CV)	-0.5232112586
Kurtosis	-1.163080009
Mean	-0.09366516909
Median Absolute Deviation (MAD)	0.04207049309
Skewness	0.03080984319
Sum	-1717.163545
Variance	0.002401653803
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.1284144137	2	< 0.1%
-0.1470591558	2	< 0.1%
-0.09672408063	2	< 0.1%
-0.09421532728	2	< 0.1%
-0.09574303587	1	< 0.1%
-0.1136558862	1	< 0.1%
-0.165255878	1	< 0.1%
-0.07808213441	1	< 0.1%
-0.06809119792	1	< 0.1%
-0.1110804614	1	< 0.1%
Other values (18319)	18319	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.179993965	1	< 0.1%
-0.1799864496	1	< 0.1%
-0.1799737348	1	< 0.1%
-0.1799675671	1	< 0.1%
-0.1799397721	1	< 0.1%
-0.1799260363	1	< 0.1%
-0.1799234888	1	< 0.1%
-0.1799107624	1	< 0.1%
-0.1798868601	1	< 0.1%
-0.1798759463	1	< 0.1%

Value	Count	Frequency (%)
0.08004052685	1	< 0.1%
0.05110190654	1	< 0.1%
0.03047416775	1	< 0.1%
0.0291952103	1	< 0.1%
0.02290399001	1	< 0.1%
0.02271691308	1	< 0.1%
0.01726403649	1	< 0.1%
0.01687649833	1	< 0.1%
0.0133825007	1	< 0.1%
0.01293917793	1	< 0.1%

car_brand
Categorical

Distinct	47
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	143.4 KiB

Nissan	1303
Mercedes Benz	1279
Chevrolet	1222
Ford	1173
Volkswagen	1082
Other values (42)	12274

Length

Max length	13
Median length	6
Mean length	6.47182676
Min length	3

Characters and Unicode

Total characters	118648
Distinct characters	43
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Toyota
2nd row	Toyota
3rd row	Toyota
4th row	Toyota
5th row	Toyota

Common Values

Value	Count	Frequency (%)
Nissan	1303	7.1%
Mercedes Benz	1279	7.0%
Chevrolet	1222	6.7%
Ford	1173	6.4%
Volkswagen	1082	5.9%
Audi	1040	5.7%
Dodge	1038	5.7%
BMW	909	5.0%
Honda	890	4.9%
Toyota	856	4.7%
Other values (37)	7541	41.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nissan	1303	6.5%
mercedes	1279	6.4%
benz	1279	6.4%
chevrolet	1222	6.1%
ford	1173	5.8%
volkswagen	1082	5.4%
audi	1040	5.2%
dodge	1038	5.2%
bmw	909	4.5%
honda	890	4.4%
Other values (38)	8879	44.2%

Most occurring characters

Value	Count	Frequency (%)
e	13773	11.6%
o	9825	8.3%
a	8364	7.0%
n	7068	6.0%
d	6537	5.5%
s	6323	5.3%
r	5659	4.8%
i	5631	4.7%
t	4526	3.8%
u	4397	3.7%
Other values (33)	46545	39.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	93615	78.9%
Uppercase Letter	23242	19.6%
Space Separator	1791	1.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	13773	14.7%
o	9825	10.5%
a	8364	8.9%
n	7068	7.6%
d	6537	7.0%
s	6323	6.8%
r	5659	6.0%
i	5631	6.0%
t	4526	4.8%
u	4397	4.7%
Other values (13)	21512	23.0%

Uppercase Letter

Value	Count	Frequency (%)
M	3375	14.5%
B	2498	10.7%
C	2090	9.0%
A	1546	6.7%
V	1472	6.3%
F	1327	5.7%
N	1303	5.6%
H	1168	5.0%
R	1054	4.5%
D	1038	4.5%
Other values (9)	6371	27.4%

Space Separator

Value	Count	Frequency (%)
	1791	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	116857	98.5%
Common	1791	1.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	13773	11.8%
o	9825	8.4%
a	8364	7.2%
n	7068	6.0%
d	6537	5.6%
s	6323	5.4%
r	5659	4.8%
i	5631	4.8%
t	4526	3.9%
u	4397	3.8%
Other values (32)	44754	38.3%

Common

Value	Count	Frequency (%)
	1791	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	118648	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	13773	11.6%
o	9825	8.3%
a	8364	7.0%
n	7068	6.0%
d	6537	5.5%
s	6323	5.3%
r	5659	4.8%
i	5631	4.7%
t	4526	3.8%
u	4397	3.7%
Other values (33)	46545	39.2%

antiquity
Real number (ℝ_≥0)

ZEROS

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.710576556

Minimum	0
Maximum	13
Zeros	405
Zeros (%)	2.2%
Negative	0
Negative (%)	0.0%
Memory size	71.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	7
Q3	10
95-th percentile	13
Maximum	13
Range	13
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.848641332
Coefficient of variation (CV)	0.5735187283
Kurtosis	-1.190260072
Mean	6.710576556
Median Absolute Deviation (MAD)	3
Skewness	0.02196872808
Sum	123025
Variance	14.81204011
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
9	1694	9.2%
1	1596	8.7%
3	1537	8.4%
8	1464	8.0%
4	1442	7.9%
13	1369	7.5%
5	1353	7.4%
12	1333	7.3%
7	1316	7.2%
10	1311	7.2%
Other values (4)	3918	21.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	405	2.2%
1	1596	8.7%
2	1284	7.0%
3	1537	8.4%
4	1442	7.9%
5	1353	7.4%
6	1175	6.4%
7	1316	7.2%
8	1464	8.0%
9	1694	9.2%

Value	Count	Frequency (%)
13	1369	7.5%
12	1333	7.3%
11	1054	5.7%
10	1311	7.2%
9	1694	9.2%
8	1464	8.0%
7	1316	7.2%
6	1175	6.4%
5	1353	7.4%
4	1442	7.9%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	car_id	car_type	color	km	average_price	transmission	body_type	DI	price	sold	first_date	diff_price	diff_price_perc	car_brand	antiquity
0	0	Supra	Blue	25848512	194799.0	Manual	Sedan	NaN	228071.0	<NA>	2019-08-14	-33272.0	-0.170802	Toyota	1
1	112	Supra	Black	25913421	194799.0	Manual	Sedan	NaN	208220.0	<NA>	2019-12-28	-13421.0	-0.068897	Toyota	1
2	1497	Supra	Black	24069281	194799.0	Manual	Sedan	NaN	197099.0	<NA>	2019-11-05	-2300.0	-0.011807	Toyota	1
3	1891	Supra	Blue	21828354	194799.0	Manual	Sedan	27.0	211287.0	True	NaN	-16488.0	-0.084641	Toyota	1
4	1955	Supra	Black	25620849	194799.0	Manual	Sedan	NaN	213144.0	<NA>	2019-08-26	-18345.0	-0.094174	Toyota	1
5	2435	Supra	Blue	19606492	194799.0	Manual	Sedan	NaN	204643.0	<NA>	2019-08-07	-9844.0	-0.050534	Toyota	1
6	2645	Supra	White	21322640	194799.0	Manual	Sedan	12.0	216338.0	False	NaN	-21539.0	-0.110570	Toyota	1
7	3640	Supra	Black	27858456	194799.0	Manual	Sedan	NaN	227949.0	<NA>	2019-11-26	-33150.0	-0.170175	Toyota	1
8	3743	Supra	Red	20518362	194799.0	Manual	Sedan	13.0	212860.0	True	NaN	-18061.0	-0.092716	Toyota	1
9	4405	Supra	White	24583516	194799.0	Manual	Sedan	NaN	202939.0	<NA>	2019-08-11	-8140.0	-0.041787	Toyota	1

Last rows

	car_id	car_type	color	km	average_price	transmission	body_type	DI	price	sold	first_date	diff_price	diff_price_perc	car_brand	antiquity
18323	14019	S80	Blue	12582104	142081.0	Automatic	SUV	NaN	161964.0	<NA>	2019-09-13	-19883.0	-0.139941	Volvo	7
18324	15396	S80	Red	18468745	142081.0	Automatic	SUV	5.0	159724.0	False	NaN	-17643.0	-0.124176	Volvo	7
18325	15629	S80	Blue	15260331	142081.0	Automatic	SUV	8.0	152244.0	False	NaN	-10163.0	-0.071530	Volvo	7
18326	15855	S80	White	14868440	142081.0	Automatic	SUV	NaN	159666.0	<NA>	2019-12-18	-17585.0	-0.123767	Volvo	7
18327	16169	S80	Black	14111995	142081.0	Automatic	SUV	NaN	157873.0	<NA>	2019-10-26	-15792.0	-0.111148	Volvo	7
18328	16468	S80	Black	14232987	142081.0	Automatic	SUV	NaN	150419.0	<NA>	2019-06-16	-8338.0	-0.058685	Volvo	7
18329	16971	S80	Black	18144875	142081.0	Automatic	SUV	NaN	157175.0	<NA>	2019-11-03	-15094.0	-0.106235	Volvo	7
18330	17013	S80	Red	16447711	142081.0	Automatic	SUV	NaN	144139.0	<NA>	2019-08-12	-2058.0	-0.014485	Volvo	7
18331	18235	S80	Red	11665859	142081.0	Automatic	SUV	5.0	157358.0	True	NaN	-15277.0	-0.107523	Volvo	7
18332	18543	S80	Black	18127179	142081.0	Automatic	SUV	NaN	159423.0	<NA>	2019-06-22	-17342.0	-0.122057	Volvo	7

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Latin 1 Sup

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category